Beginning SQL Server 2012 Administration by Rob Walters Grant Fritchey

Author:Rob Walters, Grant Fritchey
Language: eng
Format: epub
Publisher: Apress®
Published: 2012-05-19T16:00:00+00:00

Displaying General Information About a Backup

You can also display general information about the backup, in what’s known as the header. The syntax is similar to that used in the other restore operations, as shown here (headerrestore.sql in the download):

RESTORE HEADERONLY

FROM DISK = 'c:\data\restoretest.bak';

Figure 9-10 shows part of the output from the header.

Figure 9-10. Partial output from RESTORE HEADERONLY

Like the FILEILISTONLY output, a lot more columns are available for the backup header. Most of them are more focused on describing the database or log being backed up and are not immediately applicable to the restore process, so we’ll go over only the columns displayed here. Table 9-2 describes those columns.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.